CREATE EXTERNAL TABLE jms_dwd.dwd_yl_oms_order_mark_expand_base_dt(
  `id` bigint COMMENT '主键ID',
  `order_id` bigint COMMENT '订单ID',
  `waybill_id` string COMMENT '运单号',
  `order_source_code` string COMMENT '订单来源code',
  `field_name` string COMMENT '打标字段名称',
  `field_value` string COMMENT '打标字段值',
  `input_time` timestamp COMMENT '录入时间',
  `update_time` timestamp COMMENT '修改时间',
  `is_delete` bigint COMMENT '是否删除 1：未删除 2：已删除')
COMMENT '订单打标拓展表'
PARTITIONED BY (
  `dt` string COMMENT '分区(yyyy-mm-dd)-inputtime')
STORED AS PARQUET
LOCATION
  '/dw/hive/jms_dwd.db/external/dwd_yl_oms_order_mark_expand_base_dt';
